BMUG Revelations

home *** CD-ROM | disk | FTP | other *** search

/ BMUG Revelations / BMUG Revelations.toast / Business / FileMaker / Sales (.txt) < prev next >

Wrap

FileMaker Pro Database | 1992-06-27 | 180KB | 1,109 lines

HBAM2001MAY84 Friday 6/26/92 ATMTRANSACTIONCREDIT BEER\WINE1 BEER\WINE2 CAFE1 CAFE2 CASHCHECKSDEPOSITED CASHTOTAL1 CASHTOTAL2 CHARGE1 CHARGE2 7STAX1 SALESTOTAL1 TAXABLEGROC1 VISA\MC1 DateB Geneva Day.B DayName (Date.) Groceries1B TaxableGroc1B Beer\Wine1B Gas1B Cafe1B Liquor1B Motel1B FishLicense1B FishTackle1B A SalesTax1B A Discount1B SalesTotal1B A Currency1B Coin1B Checks1B Print Daily Sales Enter DataB 882.27y 4570.276.74 7232.48 Daily Sales Enter Data Monthly Sales Visa\MC1B 0.00ashTotal1B A&Currency1 + Coin1 + Checks1 + Visa\MC1 ATM1B GasCard1B Charge1B NonCashTotal1B ATM1 + GasCard1 + Charge1 DrawerTotal1B CashTotal1 + NonCashTotal1 StartCash1B 153.00 A PaidOut1aB POCode1aB A PaidOut1bB POCode1b 1233.6 23.58 100.03 25.33 1382.54 1527.54 1068.54 -1630.33 1068.54 898.21 25.33 CHECKS1 CHECKS2 COIN1 COIN2 1 CURRENCY1 CURRENCY2 DATE. DISCOUNT1 DISCOUNT2 DRAWERTOTAL1 DRAWERTOTAL2 9TEL1 NONCASHTOTAL1 SALESTAX1 SALESTOTAL1 TAXABLEGROC1 VISA\MC1 DateB FISHLICENSE1 FISHLICENSE2 FISHTACKLE1 FISHTACKLE2 GASCARD1 GASCARD2 GROCERIES1 GROCERIES2 LIQUOR1 LIQUOR2 MONTH. MONTHNUM. EPOSIT1 NETDEPOSIT2 NETDRAWER1 NETDRAWER2 NONCASHTOTAL1 NONCASHTOTAL2 OICODE1 OICODE2 C OTHERINC1 ! OTHERINC2 OVER\SHORT1 OVER\SHORT2 A PAIDOUT1A PAIDOUT1B PAIDOUT2A ; PAIDOUT2B POCODE1A POCODE1B POCODE2A POCODE2B QUARTER RECDACCT1 RECDACCT2 RPTMONTH DateB A RecdAcct1B NetDrawer1B APDrawerTotal1 - StartCash1 + PaidOut1a + PaidOut1b - RecdAcct1 - StartCash1 Over\Short1B NetDrawer1 - SalesTotal1 !A OtherInc1B OICode1B NetDeposit1B AQNetDrawer1 - PaidOut1a - PaidOut1b - NonCashTotal1 + OtherInc1 + RecdAcct1 + ATM1 Groceries2B Liquor1 FishLicenses FishTackle SalesTax E Discounts SalesTotal Currency Checks Visa\MC E CashTotal GasCards111111111GasCard1 Store Charge NonCash Total Drawer Total Start Cash Paid Out a POCode a E PaidOut b POCode b Recd on Acct Net Drawer Over\Short Other Income OICode Net Deposit1 Date. E Groceries TaxableGroceries Beer & Wine Liquor Motel11 SALESTAX1 SALESTAX2 SALESTOTAL1 SALESTOTAL2 STARTCASH1 STARTCASH2 SUMATM SUMBEER\WINE SUMCAFE SUMCASHTOTAL u SUMCHARGE SUMCHECK SUMCOIN SUMCURRENCY SUMDISCOUNT SUMDRAWERTOTAL SUMFISHTACKLE SUMGAS SUMGASCARD SUMGROC e SUMLIQUOR SUMMOTEL SUMNONCASHTOTAL SUMSALESTAX SUMSALESTOTAL SUMTAXABLEGROC SUMVISA\MC TAXABLEGROC1 TAXABLEGROC2 TOTATM TOTBEER\WINE TOTCAFE TOTCASHTOTAL U TOTCHARGE TOTCHECK TaxableGroc2B Beer\Wine2B Gas2B Cafe2B Liquor2B Motel2B FishLicense2B FishTackle2B -A SalesTax2B .A Discount2B SalesTotal2B A}Groceries2 + TaxableGroc2 + Beer\Wine2 + Gas2 + Cafe2 + Liquor2 + Motel2 + FishLicense2 + FishTackle2 + SalesTax2 - Discount2 A Currency1B Coin1B Checks1B A Currency1B Coin1B Checks1B QuarterB AKNumToText (Int ((Month (Date.) / 4)) + 1) & ", " & NumToText (Year (Date.)) Month.B A"Upper (Left (MonthName (Date.),3)) Year.B Year (Date.) A MonthNum.B Month (Date.) TdateB (Date) TdateB 153.00 ;A PaidOut2aB POCode2aB =A PaidOut2bB POCode2bB ?A RecdAcct2B NetDrawer2B A=DrawerTotal2 - StartCash2 + PaidOut2a + PaidOut2b - RecdAcct2 Over\Short2B NetDrawer2 - SalesTotal2 BA OtherInc2B OICode2B NetDeposit2B 0A Currency2B Coin2B Checks2B Visa\MC2B CashTotal2B A&Currency2 + Coin2 + Checks2 + Visa\MC2 ATM2B GasCard2B Charge2B NonCashTotal2B ATM2 + GasCard2 + Charge2 DrawerTotal2B CashTotal2 + NonCashTotal2 StartCash2B 06/19/92B FridayR 0.00S 153.00Z 0.00[ none\ 0.00] none_ -306` -306a 0.00b nonec -306s 0.00t 153.00{ 0.00| none} 0.00~ September 1992 3, 1992[ none\ 0.00] none_ -306` -306a 0.00b nonec -306s 0.00t 153.00{ 0.00| none} 0.00~ September 1992 3, 1992 6/20/92 Print Quarterly Sales AQNetDrawer2 - PaidOut2a - PaidOut2b - NonCashTotal2 + OtherInc2 + RecdAcct2 + ATM2 TotGrocB Groceries1 + Groceries2 TotTaxGrocB TaxableGroc1 + TaxableGroc2 TotBeer\WineB Beer\Wine1 + Beer\Wine2 TotGasB Gas1 + Gas2 TotCafeB Cafe1 + Cafe2 JA TotLiquorB Liquor1 + Liquor2 TotMotelB Motel1 + Motel2 TotFishLicenseB FishLicense1 + FishLicense2 TotFishTackleB FishTackle1 + FishTackle2 TotSalesTaxB SalesTax1 + SalesTax2 TotDiscountB Discount1 + Discount2 TotSalesTotalB SalesTotal1 + SalesTotal2 TotCurrencyB Currency1 + Currency2 TotCoinB Coin1 + Coin2 TotCheck A}Groceries1 + TaxableGroc1 + Beer\Wine1 + Gas1 + Cafe1 + Liquor1 + Motel1 + FishLicense1 + FishTackle1 + SalesTax1 - Discount1 %(Date) & " " & Year (Date) TOTCOIN TOTCURRENCY TOTDISCOUNT TOTDRAWERTOTAL TOTFISHLICENSE TOTFISHTACKLE TOTGAS TOTGASCARD TOTGROC E TOTLIQUOR TOTMOTEL TOTNETDEPOSIT TOTNETDRAWER TOTNONCASHTOTAL TOTOTHERINC `TOTRECDACCT TOTSALESTAX TOTSALESTOTAL TOTSTARTCASH TOTTAXGROC TOTVISA\MC VISA\MC1 VISA\MC2 Checks1 + Checks2 TotVisa\MCB Visa\MC1 + Visa\MC2 TotCashTotalB CashTotal1 + CashTotal2 TotATMB ATM1 + ATM2 TotGasCardB GasCard1 + GasCard2 XA TotChargeB Charge1 + Charge2 TotNonCashTotalB NonCashTotal1 + NonCashTotal2 TotDrawerTotalB DrawerTotal1 + DrawerTotal2 TotStartCashB CashTotal1B A&Currency1 + Coin1 + Checks1 + Visa\MC1 ATM1B GasCard1B Charge1B NonCashTotal1B ATM1 + GasCard1 + Charge1 DrawerTotal1B CashTotal1 + NonCashTotal1 StartCash1B 153.00 A PaidOut1aB POCode1aB A PaidOut1bB POCode1b StartCash1 + StartCash2 TotPaidOutB A-PaidOut1a + PaidOut1b + PaidOut2a + PaidOut2b TotRecdAcctB RecdAcct1 + RecdAcct2 TotNetDrawerB NetDrawer1 + NetDrawer2 TotOver\ShortB Over\Short1 + Over\Short2 TotOtherIncB OtherInc1 + OtherInc2 TotNetDepositB NetDeposit1 + NetDeposit2 CashChecksDepositedB 5050.37 3222.01 924.63 2714.9 2117.46 1171.36 417.89 616.18 1345.54 433.33 21.57 17992.1 10840.63 795.15 3334.57 305.361 2049.57 799.7 1256.53 58.22 928.07 58.22 928.07070707070707 5050.37 3222.01 924.63 2714.9 2117.46 1171.36 417.89 616.18 1345.54 433.33 21.57 17992.1 10840.63 795.15 3334.57 305.361 2049.57 799.7 1256.53 58.22 928.07 _ -2234.439 a 14882.281 TOTOVER\SHORT TOTPAIDOUT TOTRECDACCT TOTSALESTAX TOTSALESTOTAL TOTSTARTCASH TOTTAXGROC TOTVISA\MC VISA\MC1 VISA\MC2 VISA\MCDEPOSITED YEAR. A#TotNetDeposit - TotATM - TotVisa\MC Visa\MCDepositedB TotVisa\MC ATMTransactionCreditB TotATM SumGrocB SumTaxableGrocB SumBeer\WineB SumGasB SumCafeB jA SumLiquorB SumMotelB SumFishLicenseB Date.B A Tdate - 1 SumFishTackleB SumSalesTaxB SumDiscountB SumSalesTotalB SumCurrencyB SumCoinB SumCheckB SumVisa\MCB SumCashTotalB SumATMB SumGasCardB CHECKS1 FISHLICENSE1 MOTEL1 R SALESTAX1 SUMFISHLICENSE TOTCOIN TOTOVER\SHORT xA SumChargeB SumNonCashTotalB SumDrawerTotalB SumStartCashB SumPaidOutB SumRecdAcctB SumNetDrawerB SumOver\UnderB SumOtherIncB SumNetDepositB RptMonthB SUMFISHLICENSE SUMFISHTACKLE SUMGAS SUMGASCARD SUMGROC e SUMLIQUOR SUMMOTEL SUMNETDEPOSIT SUMNETDRAWER SUMNONCASHTOTAL SUMOTHERINC SUMOVER\UNDER SUMPAIDOUT SUMRECDACCT SUMSALESTAX SUMSALESTOTAL SUMSTARTCASH SUMTAXABLEGROC SUMVISA\MC TAXABLEGROC1 TAXABLEGROC2 TDATE TOTATM TOTBEER\WINE TOTCAFE TOTCASHTOTAL U TOTCHARGE TOTCHECK A&MonthName (Date.) & " " & Year (Date.) 06/19/92B FridayR 0.00S 153.00Z 0.00[ none\ 0.00] none_ -306` -306a 0.00b nonec -306s 0.00t 153.00{ 0.00| none} 0.00~ September 1992 3, 1992 6/20/92 06/19/92B FridayR 0.00S 153.00Z 0.00[ none\ 0.00] none_ -306` -306a 0.00b nonec -306s 0.00t 153.00{ 0.00| none} 0.00~ none0z 153.00{ 0.00| none} 0.00~ 6/20/92 MOTEL1 MOTEL2 NETDEPOSIT1 NETDEPOSIT2 NETDRAWER1 NETDRAWER2 NONCASHTOTAL1 NONCASHTOTAL2 OICODE1 OICODE2 C OTHERINC1 ! OTHERINC2 OVER\SHORT1 OVER\SHORT2 A PAIDOUT1A PAIDOUT1B PAIDOUT2A ; PAIDOUT2B POCODE1A POCODE1B POCODE2A POCODE2B QUARTER RECDACCT1 RECDACCT2 RPTMONTH NetDeposit1 Groceries2 TaxableGroc2 Beer\Wine2 Cafe2 Liquor2 Motel2 FishLicense2 FishTackle2 E SalesTax2 E Discount2 SalesTotal2 E Currency2 Coin2 DrawerTotal2 StartCash2 E PaidOut2a POCode2a E PaidOut2b POCode2b E RecdAcct2 NetDeposit2 TotGroc TotTaxGroc TotBeer\Wine TotGas TotCafe E TotLiquor TotMotel TotFishLicense TotFishTackle TotCoin TotCheck TotVisa\MC TotCashTotal TotATM TotGasCard E TotCharge TotNonCashTotal TotDrawerTotal Cash&Checks Visa\MC ATM Credit COMPANY NAME Daily Sales Sheet Register #1 Register #2 Total Deposit Summary SumTaxableGroc SumBeer\Wine SumFishLicense SumFishTackle SumSalesTax SumDiscount SumSalesTotal SumCurrency SumCoin SumCheck SumVisa\MC n check this by clicking on "Enter Sales Data" and clicking the cardfile icon to move between records. Then return to the Menu and click on "Print Daily Sales" button. When the dialog box appF ears, make sure that Current Record is selected and click on OK. Printing Monthly & Quarterly Reports Make sure the printer is turned on and loaded with 8.5 X 14 paper. Click on the button for monthl Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 are calculated and you will not need to enter them. If you really mess up, or add too many new records, delete the current record by selecting "Delete Record" under the Edit Menu. Then click the OK iD n the dialog box. Printing Daily Sales Report Make sure you have the printer turned on and loaded with 8.5 X 11 paper. Then make sure you left the day you want to print as the "active record". You ca select Records Being Browsed. Then click OK and the report will print. Printing Annual Sales Report The procedure is similar to above, but the find command is not necessary. Please make sure that thJ ere are no records present from previous or future years! Additonal Help You may get additonal help in using FileMaker Pro by selecting Help from the Apple Menu or holding the key and hitting the K ? key (no shift necessary!). Pro 1.0F! Pro 1.0I Main Dictionary User Dictionary Macintosh HD Macintosh HD Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 70.27d Geneva Helvetica Courier Chicago Chicago Groceries1 TaxableGroc1 Beer\Wine1 Cafe12.27y 4570.2727 HelpB Geneva Helvetica Groceries1 TaxableGroc1 Beer\Wine1 Cafe12 Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 Charge2 Monthly SalesB Net Deposit Net Deposit Groceries2 TaxableGroc2 Beer\Wine2 Cafe2 Liquor2 Motel2 FishLicense2 FishTackle2 E SalesTax2 E Discount2 SalesTotal2 er\Wine Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 TotATM TotGasCard Enter Daily Sales Information Enter Register Tapes Enter Count Enter Register Tapes 153.00Z 0.00[ none\ 0.00] none_ -306` -306a 0.00b nonec -306s 0.00t 153.00{ 0.00| none} 0.00~ March 1992 1, 1992 06/18/922 5050.37 3222.01 924.63 2714.9 2117.46 1171.36 417.89 616.18 1345.54 433.33 21.57 17992.1 10840.63 795.15 3334.57 305.361 2049.57 799.7 1256.53 58.22 928.07 _ -2234.439 a 14882.281 06/17/92B WednesdayC 1123.04N 1123.04R 0.00S 153.00Z 0.00[ none\ 0.00] none_ -306` -1429.04a 0.00b nonec -306s 0.00t 153.00{ 0.00| none} 0.00~ -153533 -153-153 -153@ -15353une 1992 2, 1992 5050.37 3222.01 924.63 2714.9 2117.46 1171.36 417.89 616.18 1345.54 433.33 21.57 17992.1 10840.63 795.15 3334.57 2049.57 799.7 1256.53 928.07 TaxableGroc1 Beer\Wine1 Cafe1 Geneva Helvetica A Layout #7B Beer\Wine1 Cafe1 Geneva Helvetica Store Charge NonCash Total Drawer Total Start Cash E PaidOut a POCode a E PaidOut b POCode b Recd on Acct Net Drawer Over\Short Other Income OICode Geneva Helvetica Help Screen Sales Tracking Return to Menu Liquor Motel FishLicense FishTackle SalesTax Discount SalesTotal Currency Checks Visa\MC Cash Total GasCard1111111111111B Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 06/19/92B FridayR 0.00S 153.00Z 0.00[ none\ 0.00] none_ -306` -306a 0.00b nonec -306s 0.00t 153.00{ 0.00| none} 0.00~ June 1992 2, 1992 6/20/92 3688u 451.23v 281.04x 882.27y 4570.2727 Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 Enter New Day's Sales Use the mouse to select "Enter Sales Data". The previous day's data should be visible. Select the "New Record" button uisng the mouse. Yesterday's date and day of week wiB ll be inserted automatically. The date may be deleted and changed if necessary. Use the TAB key to move through each field. Use SHIFT and TAB keys to move backwards if you make a mistake. Note that some fields Helvetica Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 Return to Menu Record TaxableGroc1 Beer\Wine1 Cafe1y Beer\Wine1 Cafe1ay Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 Date. Grocery Taxable Beer & Liquor Motel Tackle A Sales Sales Total Currency TotCurrency rency Check Visa\MC Store Charge Start A Recd Short A Other Deposit Monthly Sales Report for Monthly Sales Report for Groceries1 TaxableGroc1 Beer\Wine1 Cafe1 Quarterly Sales Annual (or YTD) Saleses Enter Register Reg#1 Reg#2 Reg#1 Reg#2 Reg#1 Reg#2Reg#2Reg#2 Reg#2A Date. E Groceries TaxableGroc E Beer\Wine Cafe111 TaxableGroc1 Beer\Wine1 Cafe1 3334.57 305.361 2049.57 799.7 1256.53 58.22 928.07 _ -2234.439 a 14882.281 COMPANY NAME 928.07 _ -2234.439 a 14882.281 Quarterly SalesB Date. Grocery Taxable Beer & Liquor Motel Tackle A Sales A Sales Sales Total Currency Check Visa\MC Store Charge Start A Recd Short A Other Deposit E"Quarterly Sales Report for Quarter COMPANY NAME Total Annual (or YTD) SalesB y or quarterly printout. You next must specify the range of dates you want to print, which is done with a "Find". The cursor will be in the date box. Type in the range of dates you want like this "06/01/92...06H /30/92" Do not hit return until you type the whole range. Don't worry about the text jumping to 2 or 3 lines. When you hit return, the machine will perform the find and sort. When the print dialog box appears, ecords. Then return to the Menu and click on "Print Daily Sales" button. When the dialog box appF ears, make sure that Current Record is selected and click on OK. Printing Monthly & Quarterly Reports Make sure the printer is turned on and loaded with 8.5 X 14 paper. Click on the button for monthl Daily SalesB Date. Grocery Taxable Beer & Liquor Motel Tackle A Sales Tackle A Sales Sales Total Currency Check Visa\MC Store Charge Start A Recd Short A Other Deposit Annual Sales Report for COMPANY NAME Total Main Menu - Sales Tracking COMPANY NAME Enter Sales Get Help about Sales Print Daily Sales Print Monthly Sales Print Quarterly Sales Print Annual Sales Sort by Quit Sales Database 1123.04 1123.04 -1582.04 March 1992 1, 1992 06/18/92 06/17/92B WednesdayR 0.00S 153.00Z 0.00[ none\ 0.00] none_ -306` -3066 0.00| none} 0.00~ June 1992 2, 1992 3222.01 924.63 2714.9 2117.46 1171.36 417.89 616.18 1345.54 433.33 21.57 10840.63 795.15 3334.57 2049.57 799.7 1256.53 928.07 Return to Menu Print Monthly Sales Print Annual Sales MenuB